Exact Globe+

XML-Server: CSV import definition for Transactions

Issue:

This document describes the CSV import definition for transactions in Exact Globe

Solution:

No.	Field name	Description	Type	Remarks	Form.
1	division	Division number	Number		N3
2	journal	Journal number	Number	Obligatory	N3
3	year	Financial year	Number	Obligatory	N4
4	periode	Period	Number	Obligatory	N2
5	date	Date	Date	Not used	N8
6	csvdate	CSV date	Date	Obligatory	N8
7	entry	Entry number	Number	Obligatory	N8
8	GL	General ledger account	Number	Obligatory	N9
9	GLdescription	General ledger account description	Text	Not used	A60
10	description	Description	Text		A60
11	debtor	Debtor	Number		N6
12	debtorname	Debtor name	Text	Not used	A60
13	creditor	Creditor	Number		N6
14	creditorname	Creditor name	Text		A60
15	resource	Resource	Number		N8
16	resourcename	Resource name	Text	Not used	A60
17	yourref	Your reference	Numstr		A30
18	ourref	Our reference	Number		N8
19	currency	Currency	Text		N3
20	rate	Exchange rate	Number		N5,6
21	debet	Debit amount	Number		N8,2
22	credit	Credit amount	Number		N8,2
23	vat	VAT code	Numstr		A3
24	cc	Cost center	Numstr		A8
25	ccname	Cost center name	Text	Not used	A60
26	cu	Cost unit	Numstr		A8
27	cuname	Cost unit name		Not used	A60
28	quantity	Quantity	Number		N6,3
29	serialnumber	Serial number	Numstr		A20
30	serialnumbername	Serial number name	Text	Not used	A60
31	item	Item	Numstr		A30
32	itemname	Item name	Text	Not used	A60
33	warehouse	Warehouse	Number		A4
34	warehousename	Warehouse name	Text	Not used	A60
35	warehouselocation	Warehouse location	Text		A10
36	project	Project	Numstr		A20
37	projectname	Project name	Text	Not used	A60
38	reportdate	Report date	Date	Not used	N8
39	csvreportdate	CSV report date	Date		N8
40	trstype	Transaction type	Numstr		A1
41	trsubtype	Transaction subtype	Numstr		A1
42	origin	Origin	Numstr		A1
43	postingnumber	Posting number	Number	Obligatory	N10
44	entryguid	Entry identification number	Numstr	Obligatory	nvt
45	transactionguid	Transaction identification number	Numstr	Obligatory	nvt

Explanation about the datatypes can be found in document 01.081.509 .

XML-Server: CSV import definition for Transactions

Solution:

Related topics